UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65zo9k5w53RcGJBEDqqrvogZ6u1eoAnVlaF8MRl8h8A='
WHERE
key_id = 'c25d7e79599e363cd06d5d2323ae8e690304bf26c41008c5e6b08817c5f98af7'
AND (
token = '65zo9k5w53RcGJBEDqqrvogZ6u1eoAnVlaF8MRl8h8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)