UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PELVhEedZ4IPO0VTFyp8RwH3ScUgZcgO7fAC1L48WE='
WHERE
key_id = 'a9255a1d7a06c0e40f6dde72f43c74dd9011ea731ba77e893a216a0bd5cfd298'
AND (
token = '6PELVhEedZ4IPO0VTFyp8RwH3ScUgZcgO7fAC1L48WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)