UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2C72pw1y4lxpJrvGzGeaeoFLXKQt/A8IUnLOFVIAJ0='
WHERE
key_id = '74bcb3559ef0401c786a601f43137ec7830701abe8238b8d3fecf19197a4cb5e'
AND (
token = 'z2C72pw1y4lxpJrvGzGeaeoFLXKQt/A8IUnLOFVIAJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)