UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfriYZBnxmlMbAdCh7qYZWYsBhbEIoW/JDC4JXm3O8g='
WHERE
key_id = 'abb53bd44307118ae64762102130064506cdfd1f691323108105109669ca80f2'
AND (
token = 'hfriYZBnxmlMbAdCh7qYZWYsBhbEIoW/JDC4JXm3O8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)