UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wj7M+5g5HHd3zxe3k1OZzvfUAVfMcGuk3SmHdqkRZ40='
WHERE
key_id = 'ed1b9c65b95815171dd6ec2be6dbeb4c961b6c0a14abf8df2717e5591ba528d4'
AND (
token = 'wj7M+5g5HHd3zxe3k1OZzvfUAVfMcGuk3SmHdqkRZ40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)