UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A3UT5i1qInKlP6UwyBc7ni8e0MEADZl/SVS59/4y5JE='
WHERE
key_id = 'e4cde325b4f8a5a2a447b54c8ae25ad7e22bebb82cfd77aa5a88065eade1ed1b'
AND (
token = 'A3UT5i1qInKlP6UwyBc7ni8e0MEADZl/SVS59/4y5JE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)