UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PE0hj8WtueycD7vuLUE0pqkk4fI9W8gmg/UXU9McXsA='
WHERE
key_id = 'a3bbcef1917c98fe869e3cd305b4d404d123433e9df1a185dd9dce19dc112033'
AND (
token = 'PE0hj8WtueycD7vuLUE0pqkk4fI9W8gmg/UXU9McXsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)