UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWq8R8v4zSwzeaPzsyTTnls3gWiloq4Vit6yG6yXdRw='
WHERE
key_id = '6ce0bf6a00a62ff7b75709920ef8096633e7c596865c924dcf30676c3b73ab19'
AND (
token = 'sWq8R8v4zSwzeaPzsyTTnls3gWiloq4Vit6yG6yXdRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)