UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4z29XJvUd5z4XC0tXiWPBULu1jLpSPNXcG4iam4Omow='
WHERE
key_id = '5ba8dfaa5080f9897fd8c63e41ebf764845da2250e201d838147cf3736663327'
AND (
token = '4z29XJvUd5z4XC0tXiWPBULu1jLpSPNXcG4iam4Omow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)