UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1k0tPHH6Q4YvGXXEWfcD7IMmM57pmF0Q5LYo7iVU0o='
WHERE
key_id = '842d8f47ef26e0acf6cf733d7a81bb119ea7ae9af92438838f1cabb5bb3e5234'
AND (
token = 'X1k0tPHH6Q4YvGXXEWfcD7IMmM57pmF0Q5LYo7iVU0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)