UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKIUVQcaUnogNZixex1R6EpgV/IG89toaRG179aVrkY='
WHERE
key_id = '427b50e0d62cf36ee0b325009e712cdcfd9bf1070db0ef792f78aa3aeda7d95b'
AND (
token = 'hKIUVQcaUnogNZixex1R6EpgV/IG89toaRG179aVrkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)