UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHEDrTAzioh4BL87zsBUqecf1U7juuGPuNZI7YH2ZaE='
WHERE
key_id = '8f45ec6d73aa11e0825d6eb83596a628cc419a06bf5cdf824161fb545465de64'
AND (
token = 'tHEDrTAzioh4BL87zsBUqecf1U7juuGPuNZI7YH2ZaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)