UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfTm1+fBciTlSe8vUQGXeVSexP4l+Srx9HcSypIVEd0='
WHERE
key_id = 'fb23ef1fc1a4fb28240c9143e9a9b29d3a63301d81ae517590eff0486680b797'
AND (
token = 'xfTm1+fBciTlSe8vUQGXeVSexP4l+Srx9HcSypIVEd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)