UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnXvlAv5xzbyLn3ghyzKAg7AYC9QdXHYLzJ2e2nPuMs='
WHERE
key_id = '7fb930ce7c76de14575caeb2514db663363a70082807a1e23285843a686f9758'
AND (
token = 'xnXvlAv5xzbyLn3ghyzKAg7AYC9QdXHYLzJ2e2nPuMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)