UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4jqfX4QK1guWA+vuDy5ZTiAYH7YBbBP7HoNtT785V8='
WHERE
key_id = '9101f7169d8ecf783acd4532d7525072fce07df87bce5628b648510ee4b57b96'
AND (
token = 'v4jqfX4QK1guWA+vuDy5ZTiAYH7YBbBP7HoNtT785V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)