UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K2oghr8P5iQRcJ0nsAXPqO3cb/10WuMACOpT3Gud2ik='
WHERE
key_id = 'c64b2caa5bbe7d1f06bca5c342a23af99eb9609d32c093853603f4666617efef'
AND (
token = 'K2oghr8P5iQRcJ0nsAXPqO3cb/10WuMACOpT3Gud2ik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)