UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lhj8WwZeMoa2CliDYJWcUp2Y2EwK5kWsTVK3npIKV28='
WHERE
key_id = '05ac5ec3e6b92b1dfe0a94b779f0c26781980af8097ecd592628e59a1fdbc570'
AND (
token = 'Lhj8WwZeMoa2CliDYJWcUp2Y2EwK5kWsTVK3npIKV28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)