UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kj7MifTb3ADGw7rgbJdGxKx38jyM5e7NPcVwW6t7tu0='
WHERE
key_id = '3c9e9f1ce233d6a2d440d90fa18ba851062af584e735eeb66efd61961fe65ef7'
AND (
token = 'Kj7MifTb3ADGw7rgbJdGxKx38jyM5e7NPcVwW6t7tu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)