UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWD8WE6dtQ62c4PrpH6aoi7ISz+xYD0gzrk05YRU8d8='
WHERE
key_id = '4164ffd140c1abdeba29c843cabfe64115dad6ac545813032c763b9ad96ed19e'
AND (
token = 'pWD8WE6dtQ62c4PrpH6aoi7ISz+xYD0gzrk05YRU8d8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)