UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTOzyHrCtH7o+PI+OfS/Pzuuq7JXR9fJ/V/bkvgXjko='
WHERE
key_id = 'd28cc30e55ca1af27eea0331e060548dbad92da104892b831607910824362826'
AND (
token = 'zTOzyHrCtH7o+PI+OfS/Pzuuq7JXR9fJ/V/bkvgXjko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)