UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thxlF/9RTR+x1ISFubFLdkaGqX0CcjnVv6IMH5B/eUY='
WHERE
key_id = '6fbbbf26dfd46699094c1eb2aa1fddfce404be4b415e6aba8d69694d5610ad3d'
AND (
token = 'thxlF/9RTR+x1ISFubFLdkaGqX0CcjnVv6IMH5B/eUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)