UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ia0gYeVzYLoWVvASIS4r6/8gpNlZ2d2iOhRY0+h7uA8='
WHERE
key_id = '9e695805d2ec6d38cc2fd548a9e678901f51f2d1a074166047f33147768d8f68'
AND (
token = 'ia0gYeVzYLoWVvASIS4r6/8gpNlZ2d2iOhRY0+h7uA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)