UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BByBgCvA36eSFu8wsoL5+66pwfWkia4HhmT7gf9cTl0='
WHERE
key_id = '99802b7dcf303869e1328f01814038018f0229be6c2f6d44b1cd7bec47741162'
AND (
token = 'BByBgCvA36eSFu8wsoL5+66pwfWkia4HhmT7gf9cTl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)