UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NxK5XDXooDu+SXzK4p0T+jMAC8IJLp6eHSlTa4WN04='
WHERE
key_id = '731743e730912ccb656bc39b3edc576cb0df360f56c4d45ae642d6f6906ec5b2'
AND (
token = '4NxK5XDXooDu+SXzK4p0T+jMAC8IJLp6eHSlTa4WN04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)