UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3fOyK+vd4Y6vWynPNdXf+ubRbFpUAoVYwdyQvGrY+XI='
WHERE
key_id = 'deaf566e995149497a8018bb5b4170592ded5ef89d6b7c385db1a5913a4448e9'
AND (
token = '3fOyK+vd4Y6vWynPNdXf+ubRbFpUAoVYwdyQvGrY+XI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)