UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AB3zDte4af7VoQygqVJHN5UOPGZWXlK02N4aQRfV+cI='
WHERE
key_id = 'a46bfbe1ea8ef230b34bb46d0084fc1ca8d59b9eb8acdd589b2821ba3e31f783'
AND (
token = 'AB3zDte4af7VoQygqVJHN5UOPGZWXlK02N4aQRfV+cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)