UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZSKy8W4HpZ8RxQGL6yhXZsplPJod6m3ZUeP/10bgKDw='
WHERE
key_id = 'e0a804ac6d6fe09c5251562cf4cdf02e5308214527c1ce727d2ce32cb96039f4'
AND (
token = 'ZSKy8W4HpZ8RxQGL6yhXZsplPJod6m3ZUeP/10bgKDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)