UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J52jYF9pPFmLNV/xGrOiXyYAKLUzXQ+yLwVjl249xGU='
WHERE
key_id = 'cfc281c9ed4943a7bac49c6d3b930bdb3bffff3fec5204fef1cd3d2bc5158a0a'
AND (
token = 'J52jYF9pPFmLNV/xGrOiXyYAKLUzXQ+yLwVjl249xGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)