UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5PY0ylaS+UKEVvDHc0C57AiRko6v7icZPFeZDUwVnRU='
WHERE
key_id = 'fe8882d02e481c5bf234a6850ba8016d40f2c34e84582e535c7268d6a5937402'
AND (
token = '5PY0ylaS+UKEVvDHc0C57AiRko6v7icZPFeZDUwVnRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)