UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qy1tdGMIVw9NeHfhNAP1TKQKOQxKCpn4XD61jS7dCCY='
WHERE
key_id = '0c0f09301db5479bd172c697303e8f78f70920bb4796f928529d04b66b0fc718'
AND (
token = 'qy1tdGMIVw9NeHfhNAP1TKQKOQxKCpn4XD61jS7dCCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)