UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hb3AkfStOQY57a01IpVXG2NVKyIq+TF7Zu5mmy7lJ4='
WHERE
key_id = '67965bea4771b7e439b6899bb8361c67dfae3a8773d1290228d83e7590f19083'
AND (
token = '2hb3AkfStOQY57a01IpVXG2NVKyIq+TF7Zu5mmy7lJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)