UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgN7TgTTIXKKzM7AvLk+X66m8gDT9qpzFcQ+gUq9HUk='
WHERE
key_id = '967f04709774be0ae2080d0fc7cc742b042fb11a3cc4d2f9886bab001c298285'
AND (
token = 'pgN7TgTTIXKKzM7AvLk+X66m8gDT9qpzFcQ+gUq9HUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)