UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KlwVHy0bn30SJ+XyFrc5M+1h8limFIoSbzGk/VIOWKs=' 
WHERE 
  key_id = '23d9350a3388532f96d5eeaddb8f2c1b12c91f0552ae67fe4c11cebbe626fa6a' 
  AND (
    token = 'KlwVHy0bn30SJ+XyFrc5M+1h8limFIoSbzGk/VIOWKs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045