UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G0T6RJ4J3ymwESR8x9aO0kndC3lkH/MvyMMzm4PxHdU='
WHERE
key_id = '00badc61befc66ad951b21f5098ef82923238bf76111553515b86a1ee1743be3'
AND (
token = 'G0T6RJ4J3ymwESR8x9aO0kndC3lkH/MvyMMzm4PxHdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)