UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yI2IuO6laDSscz6nudGnB2sBcWlzj/LWy6VZzI62evE='
WHERE
key_id = '0bb743701905bc4407819a7eb46873584bcf5094919bf7e067028ac40775246d'
AND (
token = 'yI2IuO6laDSscz6nudGnB2sBcWlzj/LWy6VZzI62evE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)