UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jxI7F5y+pPurSDFx0rJENZ9hbTLzGD+tbR+9XTr5KB8=' 
WHERE 
  key_id = 'e938c49f141b1d69fb23af2ff77ed44de26c89ed877dd6b9753816824f7bd32b' 
  AND (
    token = 'jxI7F5y+pPurSDFx0rJENZ9hbTLzGD+tbR+9XTr5KB8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038