UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'grGyv5os6WvKOj7tkQchAYnUMA9SPEZnUm6P2QcnuXM='
WHERE
key_id = 'ca9c876d9e0655f4a4fe7b917e4233a9d8f529641dbb063cce5b4719b4303d7b'
AND (
token = 'grGyv5os6WvKOj7tkQchAYnUMA9SPEZnUm6P2QcnuXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)