UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vn1/k/GEgPNU7m3fsKgOTakW/0Xk217ZvroMe3MZz3E='
WHERE
key_id = '5b09b98f715eed07f6df51f9711f73757447dc2770244cfac7ddce3074180ee4'
AND (
token = 'vn1/k/GEgPNU7m3fsKgOTakW/0Xk217ZvroMe3MZz3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)